<?php 
	header("content-type:text/html;charset=utf-8");
	$dsn = "mysql:host=127.0.0.1;dbname=07c;charset=utf8";
	$pdo = new PDO($dsn,'root','root');
	$sql = "select * from excel";
	$st = $pdo->query($sql);
	$data = $st->fetchAll(PDO::FETCH_ASSOC);
 ?>
 <!DOCTYPE html>
 <html lang="en">
 <head>
 	<meta charset="UTF-8">
 	<title>Document</title>
 </head>
 <body>
 	<center>
 		 <table border="1">
 		<tr>
 			<td>ID</td>
 			<td>名称</td>
 			<td>密码</td>
 			<td>确认密码</td>
 			<td>时间</td>
 			<td>操作</td>
 		</tr>
 		<?php foreach ($data as $k => $v): ?>
 			<tr>
 				<td><?php echo $v['id']?></td>
 				<td><?php echo $v['name']?></td>
 				<td><?php echo $v['pwd']?></td>
 				<td><?php echo $v['rpwd']?></td>
 				<td><?php echo $v['shijian']?></td>
 				<td>
 					<a href="delete.php?id=<?php echo $v['id']?>">删除</a>
 					<a href="sven.php?id=<?php echo $v['id']?>">修改</a>
 				</td>
 			</tr>
 		<?php endforeach ?>
 	</table>
 	</center>

 </body>
 </html>